HsApplicationQuestion 
Logical Entity Name  HsApplicationQuestion 
Default Table Name  HsApplicationQuestion 
Physical Only  NO 
Owner  dbo 
Definition 
 
Note 
 

HsApplicationQuestion Columns 
ColumnName  Domain  Datatype  NULL  Definition 
HsApplicationQuestionID(PK)    int  NO 
 
Code    char(8)  NO 
 
Descrip    varchar(500)  NO 
 
Active    bit  NO 
 
HsApplicationID(FK)    int  NO 
 
QuestionType    char(1)  NO 
 
Type    char(1)  NO 
 
Required    bit  NO 
 
QuestionNumber    int  NO 
 
HsSystemQuestionID    int  YES 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
Ts    timestamp  NO 
 

HsApplicationQuestion Primary and Unique Keys 
Key Name  Key Type  Keys 
PK_HsApplicationQuestion_HsApplicationQuestionID  PrimaryKey  HsApplicationQuestionID 

HsApplicationQuestion Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
HsApplication  Non-Identifying  One To Zero or More  FK_HsApplicationQuestion_HsApplicationID_HsApplication_HsApplicationID      HsApplicationID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_HsApplicationQuestion_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
HsApplicationQuestionResponse  Non-Identifying  One To Zero or More  FK_HsApplicationQuestionResponse_HsApplicationQuestionID_HsApplicationQuestion_HsApplicationQuestionID        NO  YES 
HSRoomMateMatchQuestion  Non-Identifying  One To Zero or More  FK_HSRoomMateMatchQuestion_HsApplicationQuestionID_HsApplicationQuestion_HsApplicationQuestionID        NO  YES 
HsStudentApplicationAnswers  Non-Identifying  One To Zero or More  FK_HsStudentApplicationAnswers_HsApplicationQuestionID_HsApplicationQuestion_HsApplicationQuestionID        NO  YES 

HsApplicationQuestion Check Constraints 
Check Constraint Name  CheckConstraint 

HsApplicationQuestion Storage 
STORAGE OPTION  STORAGE VALUE 
Filegroup  PRIMARY 
Text Image File Group   

HsApplicationQuestion Where Used - Model Usage 
Mapped Object  Is User Defined?  Denormalization Mappings  Description  Bound Attachments 
Logical
dbo.HsApplicationQuestion 
NO       
Physical (Microsoft SQL Server)
dbo.HsApplicationQuestion 
NO       

HsApplicationQuestion Where Used - Submodel Usage 
Model  Submodel Usage 
Logical  Main Model 
Physical (Microsoft SQL Server)  Main Model 
Physical (Microsoft SQL Server)  Housing 

HsApplicationQuestion Data Movement Rules 
Name  Type  Rule Text/Value